OK so here is my Excel Question.?

Question

So I have Cell G5 which is simply a user input cell.

In Cell H5, would like to get this accomplished

if g5*.25<=150 Then put 150 in Cell H5

if g5*.25<0, Then put 150 in cell H5

if g5 is blank, Then put a 0 in cell H5 or leave H5 blank

Otherwise, multiply g5*.25 and put the contents in H5

I had this forumla in there

=IF(G5*0.25<=150,150,G5*0.25)

But got no where, my problem is that it calcualtes correctly, but when a cell is blank or has no user input, lets say I left g5 blank, it would still return "150", how would I make h5 stay blank in this situation

Thanks as Always! You Guys are a great help! :)

Answer 1

you&#039;re pretty much there.  just do this

=IF(ISBLANK(G5), &quot;&quot;, IF(G5*0.25&lt;=150,150,G5*0.25))

ie: create an IF within an IF stmt.  First test if it&#039;s blank.  If it is blank, then stay blank.  If it&#039;s not blank, then do the IF statement you created.