| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if formulas
i am trying to create a conditional formula to
if cell j4 is greater than 0 multiply cell p4 by 3%, if cell j4 is zero return a result of zero. i want the calculation to be in cell k4 any help would be appriciated J. Davis |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if formulas
=IF(J40,P4*3%,0)
This will also return 0 if J4 is negative best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "J.davis" wrote in message ... i am trying to create a conditional formula to if cell j4 is greater than 0 multiply cell p4 by 3%, if cell j4 is zero return a result of zero. i want the calculation to be in cell k4 any help would be appriciated J. Davis |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if formulas
Thank you
"Bernard Liengme" wrote: =IF(J40,P4*3%,0) This will also return 0 if J4 is negative best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "J.davis" wrote in message ... i am trying to create a conditional formula to if cell j4 is greater than 0 multiply cell p4 by 3%, if cell j4 is zero return a result of zero. i want the calculation to be in cell k4 any help would be appriciated J. Davis |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if formulas
In K4 enter
=IF(J4=0,0,IF(J40,p4*3%,"don't know what to do if J4 <0")) -- HTH Bob Phillips (remove nothere from email address if mailing direct) "J.davis" wrote in message ... i am trying to create a conditional formula to if cell j4 is greater than 0 multiply cell p4 by 3%, if cell j4 is zero return a result of zero. i want the calculation to be in cell k4 any help would be appriciated J. Davis |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if formulas
=J4*3%
Vaya con Dios, Chuck, CABGx3 "J.davis" wrote: i am trying to create a conditional formula to if cell j4 is greater than 0 multiply cell p4 by 3%, if cell j4 is zero return a result of zero. i want the calculation to be in cell k4 any help would be appriciated J. Davis |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if formulas
Sorry, I misread the post............please ignore my offering.
Vaya con Dios, Chuck, CABGx3 "CLR" wrote: =J4*3% Vaya con Dios, Chuck, CABGx3 "J.davis" wrote: i am trying to create a conditional formula to if cell j4 is greater than 0 multiply cell p4 by 3%, if cell j4 is zero return a result of zero. i want the calculation to be in cell k4 any help would be appriciated J. Davis |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Countif formulas change after doing a sort | Excel Worksheet Functions | |||
| Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
| Problem with named formula's | Excel Worksheet Functions | |||
| Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
| calculating formulas for all workbooks in a folder | Excel Worksheet Functions | |||
Hybrid Mode
