Simple Excel Formula [Closed]

Report
-
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
-
Hello,

I am trying to enter a simple formula into excel: IF F6>=0 THEN G5=F6

Cell F6 and G5 are on different pages in the same workbook.

1 reply

Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
In G5 enter =max('sheet1'!F6,0) where sheet1 is the sheet's name

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!