Simple Excel Formula

Closed

Brad - Aug 20, 2009 at 10:55 AM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Aug 21, 2009 at 06:50 AM

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.

Simple Excel Formula
Excel grade formula - Guide
Number to words in excel formula - Guide
Date formula in excel dd/mm/yyyy - Guide
Logitech formula vibration feedback wheel driver - Download - Drivers
Simple diagram of hard disk - Guide

1 response

Answer 1 / 1

Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 307
Aug 21, 2009 at 06:50 AM

In G5 enter =max('sheet1'!F6,0) where sheet1 is the sheet's name

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel

How to calculate position (1st,2nd,3rd) in excel....?

Calculation of positions in excel

formulas for 1st and 2nd position in class

Similar discussions

Subscribe To Our Newsletter!