Nested ISBlank

[mgrubbs]

Hello I have 3 cells I would like to check if blank
So if Cell B19 is blank check Cell B25 if not blank multiply B19*15 (then equation is done if its not blank, if blank go to next cell)
If B25 is Blank go to Cell B27 if not blank multiply B27*10 (then equation is done if not blank, if blank go to next cell)
If B27 is blank then null if not blank than multiply by 5 (end of equation if blank or not blank)

I have tried multiple formulas but can't complete the whole problem

thanks

 

[Fluff]

Hi & welcome to MrExcel.
How about
=IF(B19<>"",B19*15,IF(B25<>"",B25*10,IF(B27<>"",B27*5,"")))

 

[mgrubbs]

Hi & welcome to MrExcel.
How about
=IF(B19<>"",B19*15,IF(B25<>"",B25*10,IF(B27<>"",B27*5,"")))

I tried that but it doesn't look for B25 if B19 is blank

 

[Special-K99]

Your description doesn't make sense.

If B25 is Blank go to Cell B27 if not blank
multiply B27*10 (then equation is done if not blank, if blank go to next cell)
If B27 is blank then null

if not blank than multiply by 5 (end of equation if blank or not blank)

(We're still talking about B27 aren't we, no other cell has been mentioned)
But B27 has ALREADY been checked for BOTH being blank and not blank above

 

[mgrubbs]

OK so here is the situation
If I look at B19 and it is blank I need excel to look at at B25 if that is blank it needs to look to B27
But if B19 has a number in it, it needs to be calculated and then excel doesn't need to look at B25 or B27

does that make sense?

 

[Fluff]

That makes perfect sense & it's exactly what the formula I supplied does.

Are you sure that B19 is blank? Also if it doesn't work for you, what does the formula return?

 

[mgrubbs]

thank you so much, I hit something when I copied the formula in and it skewed it... it works perfectly like you said
Thank you so so so much
Mary

 

[Fluff]

Glad to help & thanks for the feedback