| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with formula
I am looking for help with the following formula
=IF(AND(H45<$B$1,A45<207003),($B$1-H45)/(H45-G45)*I45,($B$1-H45-($B$1-H45)/7)*2) I want to have something else onto the formula which says that if the entry is less than 0 then enter "" Any ideas? Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help with formula
=IF(H45<0,"",IF(AND(H45<$B$1,A45<207003),($B$1-H45)/(H45-G45)*I45,($B$1-H45-($B$1-H45)/7)*2))
"Funkyfido" wrote: I am looking for help with the following formula =IF(AND(H45<$B$1,A45<207003),($B$1-H45)/(H45-G45)*I45,($B$1-H45-($B$1-H45)/7)*2) I want to have something else onto the formula which says that if the entry is less than 0 then enter "" Any ideas? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
