Error in Nested IF formula

RAMU

Active Member
Joined
Dec 11, 2009
Messages
296
Dear Friends,
I am trying a nested if formula like this
=IF(AND($F4="D",(AE4<=60)),AF4*0.005,IF(AND($F4="D",(AE4<=90)),AF*0.0025,IF(AND($F4="D",(AE4<=120)),AF4*0.0015,IF(AND($F4="D",(AE4>120)),AF4*0,IF(AND($F4="",(AE4<=45)),AF4*0.01,IF(AND($F4="",(AE4<=60)),AF4*0.005,IF(AND($F4="",(AE4<=90)),AF4*0.0025,IF(AND($F4="",(AE4<=120)),AF4*0.0015,IF(AND($F4="",(AE4>120)),AF4*0,0)))))))))

"F" column is carrying word "D" or blank, AE column is signifying Days, & AF column is a value. I am trying to calculate a figure. But when "F" column's cells are "D" & "AE" column (Days) is carrying figure 61 to 90, result is coming #NAME?
Can't figure out my mistake in formula.
Pls help.

Regards
RAMU
 

Some videos you may like

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
19,409
Office Version
  1. 2013
Platform
  1. Windows
Depending on your version of excel, you may be exceeding the IF limit. On older versions you can't have more than 7 It's in a formula...and you are using 9 IFs
 

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
7,125
You are welcome

btw. update your profile about Excel version & OS
 

Watch MrExcel Video

Forum statistics

Threads
1,114,440
Messages
5,547,924
Members
410,818
Latest member
Beginner99
Top