Fri 3 Oct 2008, 15:54Delegate Graham said...
Graham has attended:
Excel Advanced course
If formulas
if say a4 = 1 then c4 = g4 but if a4 is more than 1 then b4 needs to equal g4. when you put 0 as the false statement the formula comes up false. How can you write this so it comes up as correct
Fri 10 Oct 2008, 14:17Trainer Amanda said...
RE: if formulas
Hello Graham
Thank you for your question.
Can you please expand a bit more on your explanation - I'm not quite sure what you require the IF formula to do for you?
Kind regards
Amanda
