Topic starter
Sorry for this- this will be really obvious to the STW Excel Massive.
I'm using Excel 2010, and want to do the following (pseudocode)
If 2 conditions are met [if the contents of U10 are > 0, and the contents of R10= "Manual"], take the contents of cell U10, and add 500 to it-
else
If the contents of U10 are >0, just give me the contents of U10,
else
say "No Options Available".
this doesn't quite work:
=IF(AND(U10>0, R10="Manual", U10+500), if(U10>0, U10) "No Options Available")
Can anyone see where I'm going wrong?
Posted : 11/11/2013 2:44 pm
That should work, just the AND closing bracket and nested IF brackets are in the wrong place:
=IF(AND(U10>0, R10="Manual"), U10+500, IF(U10>0, U10, "No Options Available"))
Posted : 11/11/2013 2:50 pm
Topic starter
Thanks KG!
Posted : 11/11/2013 2:54 pm