IF Statement returning #Value; not sure why?

Doug Jefferson

Board Regular
Joined
Nov 4, 2010
Messages
60
=IF($AE2,"CHRY"), IF($E2="XX",'All BBK Age'!$A$1, VLOOKUP($H2,$AK:$AL,2,FALSE) + M2 - 1), IF($E2="XX",'All BBK Age'!$A$1,VLOOKUP($G2,$AK:$AL,2,FALSE)+I2-1)

My formula above is returning the following #Value in the cell; this is the result of Excels "fix" to my formula.

All of the cells noted in the formulas have values populated in them.

I think I have something missing in my formula but i am not seeing it. Any assistance would be appreciated.

Thank you.

Doug
 

Some videos you may like

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

Titian

Well-known Member
Joined
Dec 17, 2004
Messages
567
Is it that =IF($AE2,"CHRY"),

should be =IF($AE2="CHRY"), ?
 

gsistek

Well-known Member
Joined
Apr 4, 2011
Messages
660
What is in $AE2? If you want to check if that is "CHRY" then try this:
=IF($AE2="CHRY", IF($E2="XX",'All BBK Age'!$A$1, VLOOKUP($H2,$AK:$AL,2,FALSE) + M2 - 1), IF($E2="XX",'All BBK Age'!$A$1,VLOOKUP($G2,$AK:$AL,2,FALSE)+I2-1))
 

Jonmo1

MrExcel MVP
Joined
Oct 12, 2006
Messages
44,061
For one thing, you ENDED the first if with a ). You probably intended to NEST the 2nd If into the false part of the first if
=IF($AE2,"CHRY"), IF($E2="XX",'All BBK Age'!$A$1,...
Anything after that red ) doesn't really make sense..

Instead of asking to 'fix' a formula that doesn't do what you want..
Try explaining in words what you want to accomplish, then we can work on building a formula that does do what you want.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,156
Messages
5,600,040
Members
414,357
Latest member
Gemma_R

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top