Formula Issue With Blank Cells

Hello Again,

I have a small issue with formula. I an calculating % for Increasing & Decreasing amount. Not the problem is if i leave the cell blank formula is not working. I have to enter cell value as 1 (One) in range F3:J10.

Want i want here is i want to leave the cells blank instead of returning the value as 1. Can any one help me please.

Sample file is attached.

Have you tried a placeholder?

Also probably best NOT to attach macro-enabled files....

Sorry but i have just prepare a dummy for upload from original file.

I don't know about placeholder

Sorry but i have just prepare a dummy for upload from original file.

I don't know about placeholder

could you post your formula?

In D3 >>> =SUM(($AO28+$BL28)*PRODUCT($E$3:$E$10)+$BF28*O3)*$F$3

In E3>>> =IF(B14<>0,B14,1), F4>>> =IF(B15<>0,B15,1), con... uptill E10

In F3>>> =IF(B24<>0,B24,1)

Sample File is attached for your clarification.

My issue is i don't want to enter 1 (One) in these cells. I want to keep it blank but formula is not working.

In D3 >>> =SUM(($AO28+$BL28)*PRODUCT($E$3:$E$10)+$BF28*O3)*$F$3

E3>>> =IF(B14<>0,B14,""),
F4>>> =IF(B15<>0,B15,""),
F3>>> =IF(B24<>0,B24,""),


might work....

i did not get what you are trying to tell me

just tried it in your file - seems to work, use [ " " ] (= double quotes) instead of 1

sorry change your formulas - take out the 1 and replace with " "
that will give a blank value

Thanks for your advice now i want to change my formula to

=SUM(($AO28+$BL28)*PRODUCT($B$14:$B$21)+$BF28*J3)*$F$3. Again it is not working. any solution please

Sorry the aim is when i enter a % value in cell B14 the it should apply to complete range B4:D10 & D3

Hi Again

That is beyond my knowledge - sorry! If the blanks issue worked perhaps you could try a new post with the other problem? Bye!

Thanks Jonathan.

I will start new thread. Reputation added and topic marked as closed.

good luck with the new post