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 |