| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
If Then help needed
I need a formula that basically works like this....
If the total (currently =F14-F47) is less than zero show zero, else show the number. any suggestions?? Russell |
|
#2
|
|||
|
|||
|
=if(f14-f47<0,0,f14-f47)
-- Don Guillett SalesAid Software "RGT" wrote in message ... I need a formula that basically works like this.... If the total (currently =F14-F47) is less than zero show zero, else show the number. any suggestions?? Russell |
|
#3
|
|||
|
|||
|
One way...........
=MAX(F14-F47,0) Vaya con Dios, Chuck, CABGx3 "RGT" wrote in message ... I need a formula that basically works like this.... If the total (currently =F14-F47) is less than zero show zero, else show the number. any suggestions?? Russell |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula needed | Excel Worksheet Functions | |||
| Complex formula help needed | Excel Worksheet Functions | |||
| Complex forumula help needed | Excel Worksheet Functions | |||
| Help Needed With - If-Function | Excel Worksheet Functions | |||
| If statement needed | Excel Worksheet Functions | |||
Linear Mode
