MegaSack DRAW - This year's winner is user - rgwb
We will be in touch
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?
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"))
Thanks KG!