Multiple IF functions in one cell

**Stephen.Birch** · 03-21-2013, 04:45 AM

Ok so I have a database that is based on delivery dates and if they are early on time or late I have set up extra columns with if functions in that determine if the delivery was on time early or late(because its the only way to use conditional formating in the end to add up values). However some on the database have not been delivered so this is what I currently have in the column that requires extra formulae: =IF(I2>0,1,0) I need to add that if in the cell before it says N/A to add a 0 in the cell but if N/A isnt in the box to enter a 1 if =IF(I2>0,1,0) is true so how do I do that if its possible?

**Fotis1991** · 03-21-2013, 05:04 AM

N/A is a text OR it is the result of a formula? iF IT'S RESULT, WHICH IS THE FORMULA? iF IT'S TEXT TRY THIS.

=IF(AND(I1<>"N/A",I2>0),1,0)

**Stephen.Birch** · 03-21-2013, 05:16 AM

That still hasnt worked the value is still changing to one even when the text says N/A. The N/A is a result of a previous formula does that change things?