Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi
I've been struggling with a couple of formulae, but am not sure if I am going down the right route. The first is If value A-B is positive, return as normal. If value A-B is negative, return zero (Is there a simple function for this - rather than write it into a formula ?) The second is this: If value is = A and =< B multiply by 2, but if value is B and =<C multiply by 3 I'm probably just getting the syntax messed up with this one, but any help would be much appreciated Thanks -- Tobit |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
negative dates or times are displayed as # # # # | Excel Worksheet Functions | |||
negative dates or times are displayed as # # # # | New Users to Excel | |||
Negative Times Displayed as # # # # | Excel Discussion (Misc queries) | |||
How to place parenthesis around a negative percentage calculation. | Excel Worksheet Functions | |||
Formula to make Negative Values Positive & Positive Values Negative? | Excel Discussion (Misc queries) |