Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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 |