Using multiple IF functions

  • Thread starter Thread starter weedevil
  • Start date Start date
W

weedevil

I'm at my wits end...

Here is a formula I have used to determine a cell calculation dependan
on input in another cell(d4).

=IF(D4="Short",((I4-F4)/F4)*-1,IF(D4="Long",(I4-F4)/F4))

The problem is that if D4 is empty it still returns a result. I do no
want this to happen. The cell should remain blank until D4 is filled
Any suggestions to how I allow for this?

Many thanks.

And
 
You could try,
=IF(D4=0,0,IF(D4="Short",((I4-F4)/F4)*-1,IF(D4="Long",(I4-F4)/F4)))
or
=IF(D4=0,"",IF(D4="Short",((I4-F4)/F4)*-1,IF(D4="Long",(I4-F4)/F4)))
Regards
 
Or this will only give a result if D4 is 'Short' or 'Long' ie a typo like
'Sgort' will return zero or null
=IF(AND(D4<>"Short",D4<>"Long"),0,IF(D4="Short",((I4-F4)/F4)*-1,IF(D4="Long",(I4-F4)/F4)))
=IF(AND(D4<>"Short",D4<>"Long"),"",IF(D4="Short",((I4-F4)/F4)*-1,IF(D4="Long",(I4-F4)/F4)))
Regards,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Networkdays with cells yet to be entered (creating nested if) 2
Can't change the cell back to blank when there is a date in it. 0
Need help Coding my cells correctly-3 comparisons to be made 3
Leave final cell blank 2
Multiplication problem- Please Help! 8
SUMIF? 9
IF function won't post cell values 2
balance in excel that only shows the last entry 3

Back
Top