chrisdavies71
New Member
- Joined
- Oct 20, 2019
- Messages
- 8
Hi,
So the title of this thread is probably not the most helpful but I could not come up with anything better - suggestions are welcome.
I have a formula like this:
=IF(SUM(E9+H9+K9<=8),8,SUM(E9+H9+K9))
which basically says if the sum of the values in cells E9, H9 and K9 are less than 8 then the value of the cell where the formula is should be 8, or the sum of those cells if greater than 8
Question 1 - is there a better way of writing that?
The problem I have is that if there is no value in those cells (E9, H9, K9) the formula means I get a result of 8, which makes sense but I would like it to be blank.
Question 2 - is this possible?
Regards
Chris
So the title of this thread is probably not the most helpful but I could not come up with anything better - suggestions are welcome.
I have a formula like this:
=IF(SUM(E9+H9+K9<=8),8,SUM(E9+H9+K9))
which basically says if the sum of the values in cells E9, H9 and K9 are less than 8 then the value of the cell where the formula is should be 8, or the sum of those cells if greater than 8
Question 1 - is there a better way of writing that?
The problem I have is that if there is no value in those cells (E9, H9, K9) the formula means I get a result of 8, which makes sense but I would like it to be blank.
Question 2 - is this possible?
Regards
Chris