in cell c22 I have the number 1 and in cell c23 I have the number 2.
in cell a30 is =IF(C22<=C23;B30;A31)
currently it outputs false. I always assumed this to be true...
in cell c22 I have the number 1 and in cell c23 I have the number 2.
in cell a30 is =IF(C22<=C23;B30;A31)
currently it outputs false. I always assumed this to be true...
What does:
=IF(VALUE(C22)<=VALUE(C23);B30;A31)
return... A31 being False and B30 true...
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Ah I see. what i am trying to do is if a is true and b is false then copy a cell to another cell else go to the next case. I'm a beginner with excel and could do this in VB readily.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks