I require some assistance on writing the following formula.
I have a figure that is in column D that comes from a pivot table. I have formulas in column E that give the final value.
If the value of the cell in column D is under 16 then the figure in the cell in column E is to show "16"
If the value of the cell in column D is over 16 then the figure in the cell in column E is to show what the value in column D is.
I have started the formula as shown below but need to know what I need to write to complete the formula if the value is over 16.
=IF(D77<16,"16")
Bookmarks