MS Excel Question - Addenda to IF function

  MartinT-B 11:25 26 Jan 05

Yesterday I asked a question about the calculation of commission and returning the value of commission to be deducted in a cell.

Using this formula =IF(A24=1,-D24*0.1,IF(A24=2, -D24*0.15, -D24*0.2)) works very well, but I have follow up.

If the return value is invalid (IE there is no value in Cell A24, then the result in Cell E24 is shown as £0.00 as the cell is formatted to show a currency value.

Is there anyway to add to the original formula so that there is no output in the cell? IE it just remains blank.

The reason for this is to set up a template with the formula already in place in a number or rows (say 8 for example). This would mean only needing to insert rows as needed, not inserting rows and also pasting the various formulae too. I would like it be as easy to use as possible for out bookkeeper.

Thank you for your time.

  Rigga 11:42 26 Jan 05

=IF(OR(A24="", D24=""),"", IF(A24=1,-D24*0.1,IF(A24=2, -D24*0.15, -D24*0.2)))


This thread is now locked and can not be replied to.

Nintendo Switch (Nintendo NX) release date, price, specs and preview trailer: Codename NX console…

1995-2015: How technology has changed the world in 20 years

8 things designers (and brands) need to know about the modern woman

How to speed up a slow Mac: 19 great tips to make an iMac, MacBook or Mac mini run faster | Speed…