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")
[TABLE="width: 372"]
<tbody>[TR]
[TD="width: 248"] Grouped Commissioned Weekly Cost
[/TD]
[TD="width: 248"] More Or Less than £750
[/TD]
[/TR]
[TR]
[TD="width: 248"]
[/TD]
[TD="width: 248"] Less than £750
[/TD]
[/TR]
[TR]
[TD="width: 248"] [/TD]
[TD="width: 248"] Less than £750
[/TD]
[/TR]
[TR]
[TD="width: 248"] [/TD]
[TD="width: 248"] Less than £750
[/TD]
[/TR]
</tbody>[/TABLE]
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")
[TABLE="width: 372"]
<tbody>[TR]
[TD="width: 248"] Grouped Commissioned Weekly Cost
[/TD]
[TD="width: 248"] More Or Less than £750
[/TD]
[/TR]
[TR]
[TD="width: 248"]
[/TD]
[TD="width: 248"] Less than £750
[/TD]
[/TR]
[TR]
[TD="width: 248"]
£91.98
[TD="width: 248"] Less than £750
[/TD]
[/TR]
[TR]
[TD="width: 248"]
£61.32
[TD="width: 248"] Less than £750
[/TD]
[/TR]
</tbody>[/TABLE]
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