| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Quick formula
I think I'm confusing "if" with "or"...please help. I want cell A to use the
value in cell B if there is one, otherwise I want cell A to use the value in cell C and multiply it by 2.25. Pretty easy, but I can't seem to get it to work. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Quick formula
try this
=IF(B10,B1,C1*2.25) "Scooter" wrote: I think I'm confusing "if" with "or"...please help. I want cell A to use the value in cell B if there is one, otherwise I want cell A to use the value in cell C and multiply it by 2.25. Pretty easy, but I can't seem to get it to work. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Quick formula
Hi
=IF(B1,B1,C1)*2.25 -- Regards Roger Govier "Scooter" wrote in message ... I think I'm confusing "if" with "or"...please help. I want cell A to use the value in cell B if there is one, otherwise I want cell A to use the value in cell C and multiply it by 2.25. Pretty easy, but I can't seem to get it to work. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Quick formula
IF(B1=0,C1*2.25,B1)
Vaya con Dios, Chuck, CABGx3 "Scooter" wrote: I think I'm confusing "if" with "or"...please help. I want cell A to use the value in cell B if there is one, otherwise I want cell A to use the value in cell C and multiply it by 2.25. Pretty easy, but I can't seem to get it to work. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Quick formula
Great...thank you very much.
"Mike" wrote: try this =IF(B10,B1,C1*2.25) "Scooter" wrote: I think I'm confusing "if" with "or"...please help. I want cell A to use the value in cell B if there is one, otherwise I want cell A to use the value in cell C and multiply it by 2.25. Pretty easy, but I can't seem to get it to work. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002 : Any Quick Sub Total Formula ? | Excel Discussion (Misc queries) | |||
| quick key to go to formula bar | New Users to Excel | |||
| Quick Excel formula question before I go on holiday tomorrow! | Excel Discussion (Misc queries) | |||
| I need help quick! Formula | Excel Worksheet Functions | |||
| Quick formula question | Excel Worksheet Functions | |||
Linear Mode
