Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell formulae giving negative result.
Hi,
I'm using the calculation IF(C2=49.99,39.99*0.06,IF(C2<49.99(C2-10)*0.06)) How can I stop achieving a negative result when I put a figure of less than 10 in C2? Any help very much appreciated Brian |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
VBA | Excel Worksheet Functions | |||
cell calculation check if result is negative and zero out if not l | Excel Worksheet Functions | |||
How do i get excel to format a cell for a negative result. | Excel Discussion (Misc queries) | |||
Amount or Numbers in Words | New Users to Excel |