Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell comparison formulae (?)
Hi
I wonder if anyone can help me with the formulae for A3 A4 and A5 in the following scenario A1 and A2 have positive values A3=A1-A2 up to a maximum value of 10 A4 =0 unless A3 10 in which case A4=A3-10 (i.e. whatever is above 10) up to a maximum of 50 A5 =0 unless A4 50 in which case A5=A4-50 (i.e. whatever is above 50) Many thanks if you can -- Tobit |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting Cell Using Formulae....advise please.... | Excel Discussion (Misc queries) | |||
Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
cell color index comparison | New Users to Excel | |||
how can i test whether cell contains keyed constant or a formulae | Excel Worksheet Functions | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions |