Leicester City Fox
Board Regular
- Joined
- Oct 7, 2016
- Messages
- 91
- Office Version
- 2019
- Platform
- Windows
Hi All
I have a formula that works in a table : =IF([@[GroupedCommissioned Weekly Cost ]]>750,"more than £750","Less than£750")
<tbody>
</tbody>
In the blank it is stating less than £750 when the cell isBlank. I just don’t want it to returnzero if cell is blank.
Any ideas on improving my formula to do this?
Leicester Fox
I have a formula that works in a table : =IF([@[GroupedCommissioned Weekly Cost ]]>750,"more than £750","Less than£750")
Grouped Commissioned Weekly Cost | More Or Less than £750 |
| Less than £750 |
£91.98 | Less than £750 |
£61.32 | Less than £750 |
In the blank it is stating less than £750 when the cell isBlank. I just don’t want it to returnzero if cell is blank.
Any ideas on improving my formula to do this?
Leicester Fox