Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a question about a formula:
cell AC7 has to have a formula that sound roughly like this: if P7 <=3 then 0 else if P7 4 but =15 then P7*(G7*0.05), if P7 =16 but <=30 then P7*(G7*0.06), if P7 =30 but <=365 then P7*(G7*0.07), P7 365 then P7*(G7*0.07). In all cases (but if P7<=3) the minimum value must be 3 I have tried all I knew (which isn't much) but without success.... any ideas? Thank again for any help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Commenting custom formula fields/formula on formula editor | Excel Programming |