Solve formula

sitelbanat

Board Regular
Joined
Oct 17, 2005
Messages
152
IF(($D18<=ACCOUNTING!$AB$2,0,Q18*ACCOUNTING!$AD$10),IF(AS18+AT18+AU18>=56,0,AS18+AT18+AU18+Q18*ACCOUNTING!$AD$10-56))

Can someone tell me why this is not working?
 

Some videos you may like

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,047
Office Version
  1. 365
Platform
  1. Windows
Can you tell us how it isn't working?
 

NBVC

Well-known Member
Joined
Aug 31, 2005
Messages
5,828
It looks like you have to separate and complete If statements. You can only have one and you must nest other within.

So if the first argument is False, then go to the next If statement, etc...

Try:

=IF($D18>ACCOUNTING!$AB$2,Q18*ACCOUNTING!$AD$10,IF(AS18+AT18+AU18<56,AS18+AT18+AU18+Q18*ACCOUNTING!$AD$10-56,0))
 

Watch MrExcel Video

Forum statistics

Threads
1,118,112
Messages
5,570,259
Members
412,314
Latest member
yazanwael
Top