6th April 2012, 12:17 PM
|
Suspended
|
|
Join Date: Jan 1970
Location: Melbourne
Posts: 5,359
|
|
Nope.
Some people just have no idea
I need to combine 2 Formulas into one
The First Formula is
=IF($F1<>0,B1,C1)
And that is working except it ain't exactly what I want.
What I need to add is a further IF , but I keep getting an error
I try doing this.
=IF($F1<>0 then IF($G1<>0,B1,C1))
Its not an error in the Result but a Syntax Error.
Could it be I need to change the "then" into and "and"?
I'll go try that and if no Luck I'll wait for help.
|