Error in formula

amlagu

New Member
I am trying this formula, but apparently have too many arguments, any suggestions?

=IF(L12="", H12, IF(N12<>"", H12-I12-M12, H12-I12, IF(P12<>"",H12-I12-M12-O12, H12-I12-M12)))

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

Special-K99

Well-known Member
In words what are you trying to achieve?

It's going wrong....

=IF(L12="", H12, IF(N12<>"", H12-I12-M12, H12-I12, HERE IF(P12<>"",H12-I12-M12-O12, H12-I12-M12)))

An IF condition has TWO results true or false

H12-I12-M12,

H12-I12,

The rest of it
IF(P12<>"",H12-I12-M12-O12, H12-I12-M12)))
is the point where its going wrong

Last edited:

amlagu

New Member
I have a spreadsheet where if a date appears in one cell (L6) then I want to subtract I6 from H6, but if no date appears I want to just display H6 value in Q6. But if L6 and N6 have a value, but P6 doesn't then I want Q6 to equal H6-I6-M6. If L6 and N6 and P6 all have values I want Q6 to equal H6-I6-M6-O6.
I had previously posted and kindly received the following formula which works, but I wanted to add one more condition and can’t seem to work it out myself.
The formula I was given is:
=IF(L6="", H6, IF(N6<>"", H6-I6-M6, H6-I6))

Special-K99

Well-known Member
Try

in Q6
=IF(AND(L6<>"",N6<>"",P6<>""),H6-I6-M6-O6,IF(AND(L6<>"",N6<>"",P6=""),H6-I6-M6,IF(L6<>"",H6-I6,H6)))

amlagu

New Member
Thank you so so much!!

Replies
0
Views
73
Replies
7
Views
110
Replies
2
Views
119
Replies
1
Views
87
Replies
5
Views
52