Modify IF Output based on Result

**floricita** · 01-12-2011, 11:41 AM

Hi,

I have the following formula in cell G11

=IF(G10<>"",G10-1255555,"")

I would also like to add to that, in english, if the answer to G10-1255555 is 0 or less, then write NA.

does anyone know how to do this please?

Thank you

**zbor** · 01-12-2011, 11:44 AM

Here, try:

=IF(G10="","", IF(G10>1255555,G10-1255555, NA()))

**ChemistB** · 01-12-2011, 11:45 AM

=IF(G10<>"",IF(G10-1255555<=0,"NA",G10-1255555),"")
Is that what you are looking for?

**floricita** · 01-12-2011, 11:45 AM

Thanks a lot mate.

Works perfectly

**floricita** · 01-12-2011, 11:46 AM

Wrong post

**zbor** · 01-12-2011, 11:48 AM

It's a NA() function.. You can get it in some cell as =NA()

If you want text use ChemistB solution and write "NA" instead of NA()

**DonkeyOte** · 01-12-2011, 11:58 AM

@floricita - please use appropriate thread titles per Forum Rules.

Given no. of responses already received on this thread I've modified the thread title for you. Going forward given your post count / board experience threads will be locked