formula in Excel

dhasspoke · Mar 31st, 2002, 09:59 AM

Hi there,

I need a formula in g3 through g7000. so far I have =IF(F3 >0,SUM(F3+14), "blank")and than a condition format that if "blank" than format text white.

Now I need to add to this and if d3="Conduct" f3+90 and if d3="NoCall/NoShow" f3+365. plus the above formula I already have. Is this possible? Thanks

[ This Message was edited by: dhasspoke on 2002-03-31 09:05 ]

Tom Schreiner · Mar 31st, 2002, 10:34 AM

Hi there,

=IF(F3>0,(F3+14),IF(D3="Conduct",(F3+90),IF(D3="NoCall/NoShow",(F3+365),"blank")))

Tom

dhasspoke · Mar 31st, 2002, 04:40 PM

Thanks!!

Duane · Mar 31st, 2002, 05:02 PM

One more thing - if you're using the conditional formatting to get rid of the "blank", you can always just put "" instead of "blank" - putting "" tells Excel to put what's inside the quote, which would be nothing, hence the cell would remain blank.

Mar 31st, 2002, 05:02 PM	#4
Duane Board Regular Join Date: Mar 2002 Location: Toronto Posts: 173	One more thing - if you're using the conditional formatting to get rid of the "blank", you can always just put "" instead of "blank" - putting "" tells Excel to put what's inside the quote, which would be nothing, hence the cell would remain blank. __________________ Regards, Duane h. Office2003 in WinXP o. Office2007 in Win7

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 31st, 2002, 09:59 AM	#1
dhasspoke New Member Join Date: Mar 2002 Posts: 2	Hi there, I need a formula in g3 through g7000. so far I have =IF(F3 >0,SUM(F3+14), "blank")and than a condition format that if "blank" than format text white. Now I need to add to this and if d3="Conduct" f3+90 and if d3="NoCall/NoShow" f3+365. plus the above formula I already have. Is this possible? Thanks [ This Message was edited by: dhasspoke on 2002-03-31 09:05 ]

Mar 31st, 2002, 10:34 AM	#2
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Hi there, =IF(F3>0,(F3+14),IF(D3="Conduct",(F3+90),IF(D3="NoCall/NoShow",(F3+365),"blank"))) Tom

Mar 31st, 2002, 04:40 PM	#3
dhasspoke New Member Join Date: Mar 2002 Posts: 2	Thanks!!