Basic Excel question

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
conorm
Posts: 39
Joined: Wed Apr 15, 2009 5:13 pm

Hi I want to write a formula that basically says if cell b1 is greater than 1 then show A1 otherwise show c1. Is this possible?

Thanks
Top
User avatar
pdupre1961
Posts: 410
Joined: Fri Feb 18, 2011 8:01 pm

B1 is a number
=IF(B1>1,A1,C1)

B1 is text
=IF(VALUE(B1)>1,A1,C1)
Top
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”