Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula
HELP Please! What I'm trying to do is in the one cell a simple sum to work
out the difference between two other cells then (in same cell) I want it to decide that if the figure returned is greater than £175 I want it to show £175 but if it is less than £175 I want it to show the actual figure. Is this possible??? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula
One way, something like this ..
In say, C2: =MIN(175,B2-A2) Format C2 as currency/symbol to taste Any good? hit the YES below -- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- "HeatherV" wrote: .. What I'm trying to do is in the one cell a simple sum to work out the difference between two other cells then (in same cell) I want it to decide that if the figure returned is greater than £175 I want it to show £175 but if it is less than £175 I want it to show the actual figure. Is this possible??? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula
Hi,
I assume you want in C1 the difference between B1 and A1 =if((B1-A1)175,175,(B1-A1)) if this helps please click yes thanks "HeatherV" wrote: HELP Please! What I'm trying to do is in the one cell a simple sum to work out the difference between two other cells then (in same cell) I want it to decide that if the figure returned is greater than £175 I want it to show £175 but if it is less than £175 I want it to show the actual figure. Is this possible??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|