Help with Excel please

Forum guidelines BT super discount
Other Resources My Cup of Joe » Help with Excel please Rss Feed  
Moderators: k9car363, the bear, DerekL, alicefoeller Reply
2010-03-07 12:17 PM

User image

Master
2447
200010010010010025
White Oak, Texas
Subject: Help with Excel please
I am building an Excel spread sheet and have this problem I have a 1600 pace thast is referenced to a 1600 pr cell some runners do not have a 1600 time so i want to format the 1600 pace to refer to the 1600 pr but if that cell is blank i want to to refer to the 3200 pace x.92.  so it would be =(b4) if b4 is blank than (h4)*.92.  any help with this command would be great.

2010-03-07 12:25 PM
in reply to: #2712618

User image

Elite
2729
200050010010025
Puyallup, WA
Subject: RE: Help with Excel please
Should look something like this:

=IF(ISBLANK(B4)=TRUE,(H4*0.92),B4)
2010-03-07 1:19 PM
in reply to: #2712618

User image

Champion
9407
500020002000100100100100
Montague Gold Mines, Nova Scotia
Subject: RE: Help with Excel please
I would just use:

=if(b4=0,h4*.92,b4)

ETA - on second thought it might need to be =if(b4="",h4*.92,b4)

Shane

Edited by gsmacleod 2010-03-07 1:20 PM
2010-03-07 2:58 PM
in reply to: #2712618

User image

Master
2447
200010010010010025
White Oak, Texas
Subject: RE: Help with Excel please
Thanks for the help I am getting closer
New Thread
Other Resources My Cup of Joe » Help with Excel please Rss Feed