| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I am looking for help on how to create a specific formula
I am trying to do a formula for a spreadsheet. What I need is the following
and am not sure how to do it: N4 =M4-(M4*H4)/2 ONLY IF H430 IF NOT THEN N4=M4 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I am looking for help on how to create a specific formula
In N4,
=IF(H430,M4-(M4*H4)/2,M4). HTH -- Kevin James. Tua'r Goleuni "CURTITO" wrote in message ... |I am trying to do a formula for a spreadsheet. What I need is the following | and am not sure how to do it: | N4 =M4-(M4*H4)/2 ONLY IF H430 IF NOT THEN N4=M4 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I am looking for help on how to create a specific formula
The basic approach for an IF formula is
=IF(this is true, do this, otherwise do this) You've got all of the components below. You just need to get them in the correct order. - John CURTITO wrote: I am trying to do a formula for a spreadsheet. What I need is the following and am not sure how to do it: N4 =M4-(M4*H4)/2 ONLY IF H430 IF NOT THEN N4=M4 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reusing formula | Excel Discussion (Misc queries) | |||
| need to create a formula to create a timesheet but haven't a clue | Excel Discussion (Misc queries) | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| How to create specific formula | Excel Worksheet Functions | |||
Linear Mode
