Sumproduct-remain blank

I am trying to create a column that:

- Gives me the figure in cell "X10" if Cell "J10" says "Yes" and
- Gives me 55% of the figure in "X10" if Cell "J10" says "No"
- If cell X10 is blank then I would also like this cell to remain blank

I have tried the formula below, which seems to work except for when X10 is blank. In which case it shows VALUE

=IF(J10="Yes",X10,IF(J10="No",X10*0.45,IF(X10="","")))

Try:

Please Login or Register  to view this content.

modytrane

Hello bhodo,

That's not really a SUMPRODUCT question, can you change the thread title please.....