View Single Post
  #13  
Old 6th April 2012, 01:17 PM
moeee moeee is offline
Suspended
 
Join Date: Jan 1970
Location: Melbourne
Posts: 5,359
Default

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.
Reply With Quote